Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 1119 |
| Missing cells | 4600 |
| Missing cells (%) | 27.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 131.3 KiB |
| Average record size in memory | 120.1 B |
Variable types
| Categorical | 4 |
|---|---|
| Numeric | 10 |
| Unsupported | 1 |
_id has a high cardinality: 1119 distinct values | High cardinality |
userId has a high cardinality: 258 distinct values | High cardinality |
bonusPointsEarned is highly overall correlated with bonusPointsEarnedReason | High correlation |
createDate is highly overall correlated with dateScanned and 4 other fields | High correlation |
dateScanned is highly overall correlated with createDate and 4 other fields | High correlation |
finishedDate is highly overall correlated with createDate and 5 other fields | High correlation |
modifyDate is highly overall correlated with createDate and 4 other fields | High correlation |
pointsAwardedDate is highly overall correlated with createDate and 5 other fields | High correlation |
pointsEarned is highly overall correlated with bonusPointsEarnedReason and 1 other fields | High correlation |
purchaseDate is highly overall correlated with createDate and 5 other fields | High correlation |
purchasedItemCount is highly overall correlated with totalSpent | High correlation |
totalSpent is highly overall correlated with purchasedItemCount and 1 other fields | High correlation |
bonusPointsEarnedReason is highly overall correlated with bonusPointsEarned and 2 other fields | High correlation |
rewardsReceiptStatus is highly overall correlated with finishedDate and 3 other fields | High correlation |
bonusPointsEarned has 575 (51.4%) missing values | Missing |
bonusPointsEarnedReason has 575 (51.4%) missing values | Missing |
finishedDate has 551 (49.2%) missing values | Missing |
pointsAwardedDate has 582 (52.0%) missing values | Missing |
pointsEarned has 510 (45.6%) missing values | Missing |
purchaseDate has 448 (40.0%) missing values | Missing |
purchasedItemCount has 484 (43.3%) missing values | Missing |
rewardsReceiptItemList has 440 (39.3%) missing values | Missing |
totalSpent has 435 (38.9%) missing values | Missing |
_id is uniformly distributed | Uniform |
_id has unique values | Unique |
rewardsReceiptItemList is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
purchasedItemCount has 15 (1.3%) zeros | Zeros |
totalSpent has 15 (1.3%) zeros | Zeros |
Reproduction
| Analysis started | 2023-07-19 20:07:42.611522 |
|---|---|
| Analysis finished | 2023-07-19 20:08:12.922463 |
| Duration | 30.31 seconds |
| Software version | ydata-profiling vv4.1.2 |
| Download configuration | config.json |
_id
Categorical
HIGH CARDINALITY  UNIFORM  UNIQUE 
| Distinct | 1119 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 KiB |
| 5ff1e1eb0a720f0523000575 | 1 |
|---|---|
| 601b48df0a720f05f4000238 | 1 |
| 601c11410a720f05f400028e | 1 |
| 601c2d630a7214ad280002a7 | 1 |
| 601be7120a720f05f400027a | 1 |
| Other values (1114) |
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 24 |
| Min length | 24 |
Characters and Unicode
| Total characters | 26856 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1119 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 5ff1e1eb0a720f0523000575 |
|---|---|
| 2nd row | 5ff1e1bb0a720f052300056b |
| 3rd row | 5ff1e1f10a720f052300057a |
| 4th row | 5ff1e1ee0a7214ada100056f |
| 5th row | 5ff1e1d20a7214ada1000561 |
Common Values
| Value | Count | Frequency (%) |
| 5ff1e1eb0a720f0523000575 | 1 | 0.1% |
| 601b48df0a720f05f4000238 | 1 | 0.1% |
| 601c11410a720f05f400028e | 1 | 0.1% |
| 601c2d630a7214ad280002a7 | 1 | 0.1% |
| 601be7120a720f05f400027a | 1 | 0.1% |
| 601b5cc90a7214ad2800023a | 1 | 0.1% |
| 601bc2bd0a7214ad28000262 | 1 | 0.1% |
| 601c2c3a0a720f05f40002a2 | 1 | 0.1% |
| 601b730f0a7214ad28000243 | 1 | 0.1% |
| 601bd57e0a7214ad2800026d | 1 | 0.1% |
| Other values (1109) | 1109 |
Length
| Value | Count | Frequency (%) |
| 5ff1e1eb0a720f0523000575 | 1 | 0.1% |
| 5ff36d860a720f05230005a7 | 1 | 0.1% |
| 5ff1e1f10a720f052300057a | 1 | 0.1% |
| 5ff1e1ee0a7214ada100056f | 1 | 0.1% |
| 5ff1e1d20a7214ada1000561 | 1 | 0.1% |
| 5ff1e1e40a7214ada1000566 | 1 | 0.1% |
| 5ff1e1cd0a720f052300056f | 1 | 0.1% |
| 5ff1e1a40a720f0523000569 | 1 | 0.1% |
| 5ff1e1ed0a7214ada100056e | 1 | 0.1% |
| 5ff473a90a7214ada10005c2 | 1 | 0.1% |
| Other values (1109) | 1109 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 7683 | |
| a | 2271 | 8.5% |
| 2 | 2212 | 8.2% |
| f | 1789 | 6.7% |
| 7 | 1774 | 6.6% |
| 1 | 1759 | 6.5% |
| 5 | 1614 | 6.0% |
| 6 | 1373 | 5.1% |
| 4 | 1177 | 4.4% |
| d | 1030 | 3.8% |
| Other values (6) | 4174 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 19948 | |
| Lowercase Letter | 6908 | 25.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 7683 | |
| 2 | 2212 | 11.1% |
| 7 | 1774 | 8.9% |
| 1 | 1759 | 8.8% |
| 5 | 1614 | 8.1% |
| 6 | 1373 | 6.9% |
| 4 | 1177 | 5.9% |
| 8 | 898 | 4.5% |
| 3 | 885 | 4.4% |
| 9 | 573 | 2.9% |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 2271 | |
| f | 1789 | |
| d | 1030 | |
| c | 731 | 10.6% |
| e | 610 | 8.8% |
| b | 477 | 6.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 19948 | |
| Latin | 6908 | 25.7% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 7683 | |
| 2 | 2212 | 11.1% |
| 7 | 1774 | 8.9% |
| 1 | 1759 | 8.8% |
| 5 | 1614 | 8.1% |
| 6 | 1373 | 6.9% |
| 4 | 1177 | 5.9% |
| 8 | 898 | 4.5% |
| 3 | 885 | 4.4% |
| 9 | 573 | 2.9% |
Latin
| Value | Count | Frequency (%) |
| a | 2271 | |
| f | 1789 | |
| d | 1030 | |
| c | 731 | 10.6% |
| e | 610 | 8.8% |
| b | 477 | 6.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 26856 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 7683 | |
| a | 2271 | 8.5% |
| 2 | 2212 | 8.2% |
| f | 1789 | 6.7% |
| 7 | 1774 | 6.6% |
| 1 | 1759 | 6.5% |
| 5 | 1614 | 6.0% |
| 6 | 1373 | 5.1% |
| 4 | 1177 | 4.4% |
| d | 1030 | 3.8% |
| Other values (6) | 4174 |
bonusPointsEarned
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 12 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 575 |
| Missing (%) | 51.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 238.89338 |
| Minimum | 5 |
|---|---|
| Maximum | 750 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 5 |
| median | 45 |
| Q3 | 500 |
| 95-th percentile | 750 |
| Maximum | 750 |
| Range | 745 |
| Interquartile range (IQR) | 495 |
Descriptive statistics
| Standard deviation | 299.09173 |
|---|---|
| Coefficient of variation (CV) | 1.2519883 |
| Kurtosis | -0.91662581 |
| Mean | 238.89338 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 0.89974537 |
| Sum | 129958 |
| Variance | 89455.863 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 183 | 16.4% |
| 750 | 119 | 10.6% |
| 25 | 71 | 6.3% |
| 250 | 31 | 2.8% |
| 45 | 31 | 2.8% |
| 500 | 30 | 2.7% |
| 150 | 27 | 2.4% |
| 300 | 26 | 2.3% |
| 100 | 18 | 1.6% |
| 27 | 6 | 0.5% |
| Other values (2) | 2 | 0.2% |
| (Missing) | 575 |
| Value | Count | Frequency (%) |
| 5 | 183 | |
| 21 | 1 | 0.1% |
| 25 | 71 | 6.3% |
| 27 | 6 | 0.5% |
| 40 | 1 | 0.1% |
| 45 | 31 | 2.8% |
| 100 | 18 | 1.6% |
| 150 | 27 | 2.4% |
| 250 | 31 | 2.8% |
| 300 | 26 | 2.3% |
| Value | Count | Frequency (%) |
| 750 | 119 | |
| 500 | 30 | 2.7% |
| 300 | 26 | 2.3% |
| 250 | 31 | 2.8% |
| 150 | 27 | 2.4% |
| 100 | 18 | 1.6% |
| 45 | 31 | 2.8% |
| 40 | 1 | 0.1% |
| 27 | 6 | 0.5% |
| 25 | 71 |
bonusPointsEarnedReason
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 9 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 575 |
| Missing (%) | 51.4% |
| Memory size | 8.9 KiB |
| All-receipts receipt bonus | |
|---|---|
| Receipt number 1 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) | |
| COMPLETE_NONPARTNER_RECEIPT | |
| COMPLETE_PARTNER_RECEIPT | |
| Receipt number 3 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) | |
| Other values (4) |
Length
| Max length | 83 |
|---|---|
| Median length | 27 |
| Mean length | 52.286765 |
| Min length | 24 |
Characters and Unicode
| Total characters | 28444 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Receipt number 2 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) |
|---|---|
| 2nd row | Receipt number 5 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) |
| 3rd row | All-receipts receipt bonus |
| 4th row | All-receipts receipt bonus |
| 5th row | All-receipts receipt bonus |
Common Values
| Value | Count | Frequency (%) |
| All-receipts receipt bonus | 183 | 16.4% |
| Receipt number 1 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) | 119 | 10.6% |
| COMPLETE_NONPARTNER_RECEIPT | 71 | 6.3% |
| COMPLETE_PARTNER_RECEIPT | 39 | 3.5% |
| Receipt number 3 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) | 31 | 2.8% |
| Receipt number 2 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) | 30 | 2.7% |
| Receipt number 5 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) | 27 | 2.4% |
| Receipt number 4 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) | 26 | 2.3% |
| Receipt number 6 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) | 18 | 1.6% |
| (Missing) | 575 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| receipt | 434 | |
| bonus | 434 | |
| default | 251 | |
| number | 251 | |
| 5cefdcacf3693e0b50e83a36 | 251 | |
| completed | 251 | |
| point | 251 | |
| schedule | 251 | |
| all-receipts | 183 | |
| 1 | 119 | 4.1% |
| Other values (7) | 242 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 3242 | 11.4% |
| 2374 | 8.3% | |
| c | 1872 | 6.6% |
| p | 1119 | 3.9% |
| t | 1119 | 3.9% |
| 3 | 1035 | 3.6% |
| n | 936 | 3.3% |
| u | 936 | 3.3% |
| b | 936 | 3.3% |
| o | 936 | 3.3% |
| Other values (36) | 13939 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 16827 | |
| Uppercase Letter | 4824 | 17.0% |
| Decimal Number | 3263 | 11.5% |
| Space Separator | 2374 | 8.3% |
| Close Punctuation | 251 | 0.9% |
| Open Punctuation | 251 | 0.9% |
| Other Punctuation | 251 | 0.9% |
| Connector Punctuation | 220 | 0.8% |
| Dash Punctuation | 183 | 0.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 3242 | |
| c | 1872 | |
| p | 1119 | 6.7% |
| t | 1119 | 6.7% |
| n | 936 | 5.6% |
| u | 936 | 5.6% |
| b | 936 | 5.6% |
| o | 936 | 5.6% |
| s | 868 | 5.2% |
| l | 868 | 5.2% |
| Other values (7) | 3995 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 801 | |
| T | 581 | |
| R | 581 | |
| A | 544 | |
| L | 361 | |
| P | 330 | |
| N | 252 | 5.2% |
| F | 251 | 5.2% |
| U | 251 | 5.2% |
| D | 251 | 5.2% |
| Other values (4) | 621 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 1035 | |
| 5 | 529 | |
| 6 | 520 | |
| 0 | 502 | |
| 8 | 251 | 7.7% |
| 9 | 251 | 7.7% |
| 1 | 119 | 3.6% |
| 2 | 30 | 0.9% |
| 4 | 26 | 0.8% |
Space Separator
| Value | Count | Frequency (%) |
| 2374 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 251 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 251 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 251 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 220 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 183 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 21651 | |
| Common | 6793 | 23.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 3242 | 15.0% |
| c | 1872 | 8.6% |
| p | 1119 | 5.2% |
| t | 1119 | 5.2% |
| n | 936 | 4.3% |
| u | 936 | 4.3% |
| b | 936 | 4.3% |
| o | 936 | 4.3% |
| s | 868 | 4.0% |
| l | 868 | 4.0% |
| Other values (21) | 8819 |
Common
| Value | Count | Frequency (%) |
| 2374 | ||
| 3 | 1035 | |
| 5 | 529 | 7.8% |
| 6 | 520 | 7.7% |
| 0 | 502 | 7.4% |
| ) | 251 | 3.7% |
| 8 | 251 | 3.7% |
| 9 | 251 | 3.7% |
| ( | 251 | 3.7% |
| , | 251 | 3.7% |
| Other values (5) | 578 | 8.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 28444 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 3242 | 11.4% |
| 2374 | 8.3% | |
| c | 1872 | 6.6% |
| p | 1119 | 3.9% |
| t | 1119 | 3.9% |
| 3 | 1035 | 3.6% |
| n | 936 | 3.3% |
| u | 936 | 3.3% |
| b | 936 | 3.3% |
| o | 936 | 3.3% |
| Other values (36) | 13939 |
createDate
Real number (ℝ)
| Distinct | 1107 |
|---|---|
| Distinct (%) | 98.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6117998 × 1012 |
| Minimum | 1.6040891 × 1012 |
|---|---|
| Maximum | 1.6146407 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 KiB |
Quantile statistics
| Minimum | 1.6040891 × 1012 |
|---|---|
| 5-th percentile | 1.6097889 × 1012 |
| Q1 | 1.6106516 × 1012 |
| median | 1.6119407 × 1012 |
| Q3 | 1.612704 × 1012 |
| 95-th percentile | 1.6144754 × 1012 |
| Maximum | 1.6146407 × 1012 |
| Range | 1.0551576 × 1010 |
| Interquartile range (IQR) | 2.05243 × 109 |
Descriptive statistics
| Standard deviation | 1.484091 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.00092076632 |
| Kurtosis | 2.4018826 |
| Mean | 1.6117998 × 1012 |
| Median Absolute Deviation (MAD) | 9.3145338 × 108 |
| Skewness | -0.47574632 |
| Sum | 1.803604 × 1015 |
| Variance | 2.202526 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.609687531 × 1012 | 3 | 0.3% |
| 1.610144383 × 1012 | 3 | 0.3% |
| 1.609687534 × 1012 | 3 | 0.3% |
| 1.609879107 × 1012 | 2 | 0.2% |
| 1.610390945 × 1012 | 2 | 0.2% |
| 1.609945606 × 1012 | 2 | 0.2% |
| 1.60994556 × 1012 | 2 | 0.2% |
| 1.611957559 × 1012 | 2 | 0.2% |
| 1.612972619 × 1012 | 2 | 0.2% |
| 1.612733265 × 1012 | 1 | 0.1% |
| Other values (1097) | 1097 |
| Value | Count | Frequency (%) |
| 1.604089079 × 1012 | 1 | |
| 1.604089081 × 1012 | 1 | |
| 1.604607818 × 1012 | 1 | |
| 1.604693303 × 1012 | 1 | |
| 1.604900211 × 1012 | 1 | |
| 1.604900217 × 1012 | 1 | |
| 1.605483857 × 1012 | 1 | |
| 1.605556824 × 1012 | 1 | |
| 1.609607165 × 1012 | 1 | |
| 1.609687446 × 1012 | 1 |
| Value | Count | Frequency (%) |
| 1.614640655 × 1012 | 1 | |
| 1.614634348 × 1012 | 1 | |
| 1.614633447 × 1012 | 1 | |
| 1.614626853 × 1012 | 1 | |
| 1.61462295 × 1012 | 1 | |
| 1.614620855 × 1012 | 1 | |
| 1.614613362 × 1012 | 1 | |
| 1.614607658 × 1012 | 1 | |
| 1.614607054 × 1012 | 1 | |
| 1.614604048 × 1012 | 1 |
dateScanned
Real number (ℝ)
| Distinct | 1107 |
|---|---|
| Distinct (%) | 98.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6117998 × 1012 |
| Minimum | 1.6040891 × 1012 |
|---|---|
| Maximum | 1.6146407 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 KiB |
Quantile statistics
| Minimum | 1.6040891 × 1012 |
|---|---|
| 5-th percentile | 1.6097889 × 1012 |
| Q1 | 1.6106516 × 1012 |
| median | 1.6119407 × 1012 |
| Q3 | 1.612704 × 1012 |
| 95-th percentile | 1.6144754 × 1012 |
| Maximum | 1.6146407 × 1012 |
| Range | 1.0551576 × 1010 |
| Interquartile range (IQR) | 2.05243 × 109 |
Descriptive statistics
| Standard deviation | 1.484091 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.00092076632 |
| Kurtosis | 2.4018826 |
| Mean | 1.6117998 × 1012 |
| Median Absolute Deviation (MAD) | 9.3145338 × 108 |
| Skewness | -0.47574632 |
| Sum | 1.803604 × 1015 |
| Variance | 2.202526 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.609687531 × 1012 | 3 | 0.3% |
| 1.610144383 × 1012 | 3 | 0.3% |
| 1.609687534 × 1012 | 3 | 0.3% |
| 1.609879107 × 1012 | 2 | 0.2% |
| 1.610390945 × 1012 | 2 | 0.2% |
| 1.609945606 × 1012 | 2 | 0.2% |
| 1.60994556 × 1012 | 2 | 0.2% |
| 1.611957559 × 1012 | 2 | 0.2% |
| 1.612972619 × 1012 | 2 | 0.2% |
| 1.612733265 × 1012 | 1 | 0.1% |
| Other values (1097) | 1097 |
| Value | Count | Frequency (%) |
| 1.604089079 × 1012 | 1 | |
| 1.604089081 × 1012 | 1 | |
| 1.604607818 × 1012 | 1 | |
| 1.604693303 × 1012 | 1 | |
| 1.604900211 × 1012 | 1 | |
| 1.604900217 × 1012 | 1 | |
| 1.605483857 × 1012 | 1 | |
| 1.605556824 × 1012 | 1 | |
| 1.609607165 × 1012 | 1 | |
| 1.609687446 × 1012 | 1 |
| Value | Count | Frequency (%) |
| 1.614640655 × 1012 | 1 | |
| 1.614634348 × 1012 | 1 | |
| 1.614633447 × 1012 | 1 | |
| 1.614626853 × 1012 | 1 | |
| 1.61462295 × 1012 | 1 | |
| 1.614620855 × 1012 | 1 | |
| 1.614613362 × 1012 | 1 | |
| 1.614607658 × 1012 | 1 | |
| 1.614607054 × 1012 | 1 | |
| 1.614604048 × 1012 | 1 |
finishedDate
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 553 |
|---|---|
| Distinct (%) | 97.4% |
| Missing | 551 |
| Missing (%) | 49.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6110582 × 1012 |
| Minimum | 1.6096874 × 1012 |
|---|---|
| Maximum | 1.614379 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 KiB |
Quantile statistics
| Minimum | 1.6096874 × 1012 |
|---|---|
| 5-th percentile | 1.6097881 × 1012 |
| Q1 | 1.610141 × 1012 |
| median | 1.6110908 × 1012 |
| Q3 | 1.6117693 × 1012 |
| 95-th percentile | 1.6125454 × 1012 |
| Maximum | 1.614379 × 1012 |
| Range | 4.691535 × 109 |
| Interquartile range (IQR) | 1.628371 × 109 |
Descriptive statistics
| Standard deviation | 9.5346414 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.00059182476 |
| Kurtosis | -0.79232439 |
| Mean | 1.6110582 × 1012 |
| Median Absolute Deviation (MAD) | 7.605265 × 108 |
| Skewness | 0.3062952 |
| Sum | 9.1508106 × 1014 |
| Variance | 9.0909386 × 1017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.609687534 × 1012 | 3 | 0.3% |
| 1.609687531 × 1012 | 2 | 0.2% |
| 1.609687532 × 1012 | 2 | 0.2% |
| 1.611641366 × 1012 | 2 | 0.2% |
| 1.609788557 × 1012 | 2 | 0.2% |
| 1.609788876 × 1012 | 2 | 0.2% |
| 1.611173216 × 1012 | 2 | 0.2% |
| 1.61038737 × 1012 | 2 | 0.2% |
| 1.611172426 × 1012 | 2 | 0.2% |
| 1.610144383 × 1012 | 2 | 0.2% |
| Other values (543) | 547 | |
| (Missing) | 551 |
| Value | Count | Frequency (%) |
| 1.60968745 × 1012 | 1 | |
| 1.609687461 × 1012 | 1 | |
| 1.609687475 × 1012 | 1 | |
| 1.609687483 × 1012 | 1 | |
| 1.609687493 × 1012 | 1 | |
| 1.609687499 × 1012 | 1 | |
| 1.609687502 × 1012 | 2 | |
| 1.609687509 × 1012 | 1 | |
| 1.609687511 × 1012 | 1 | |
| 1.609687512 × 1012 | 1 |
| Value | Count | Frequency (%) |
| 1.614378985 × 1012 | 1 | |
| 1.61313912 × 1012 | 1 | |
| 1.613139118 × 1012 | 1 | |
| 1.613139071 × 1012 | 1 | |
| 1.613139065 × 1012 | 1 | |
| 1.613060278 × 1012 | 1 | |
| 1.613060276 × 1012 | 1 | |
| 1.613060271 × 1012 | 1 | |
| 1.613052084 × 1012 | 1 | |
| 1.613052054 × 1012 | 1 |
modifyDate
Real number (ℝ)
| Distinct | 1104 |
|---|---|
| Distinct (%) | 98.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6118469 × 1012 |
| Minimum | 1.6096874 × 1012 |
|---|---|
| Maximum | 1.6146407 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 KiB |
Quantile statistics
| Minimum | 1.6096874 × 1012 |
|---|---|
| 5-th percentile | 1.6097897 × 1012 |
| Q1 | 1.6106599 × 1012 |
| median | 1.6119407 × 1012 |
| Q3 | 1.612704 × 1012 |
| 95-th percentile | 1.6144754 × 1012 |
| Maximum | 1.6146407 × 1012 |
| Range | 4.9532048 × 109 |
| Interquartile range (IQR) | 2.0440682 × 109 |
Descriptive statistics
| Standard deviation | 1.3615765 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.00084473068 |
| Kurtosis | -0.6315802 |
| Mean | 1.6118469 × 1012 |
| Median Absolute Deviation (MAD) | 9.128301 × 108 |
| Skewness | 0.27102152 |
| Sum | 1.8036566 × 1015 |
| Variance | 1.8538906 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.609687536 × 1012 | 3 | 0.3% |
| 1.610144388 × 1012 | 2 | 0.2% |
| 1.609855952 × 1012 | 2 | 0.2% |
| 1.61038737 × 1012 | 2 | 0.2% |
| 1.61039095 × 1012 | 2 | 0.2% |
| 1.611641366 × 1012 | 2 | 0.2% |
| 1.612225697 × 1012 | 2 | 0.2% |
| 1.612225704 × 1012 | 2 | 0.2% |
| 1.612225662 × 1012 | 2 | 0.2% |
| 1.609788876 × 1012 | 2 | 0.2% |
| Other values (1094) | 1098 |
| Value | Count | Frequency (%) |
| 1.60968745 × 1012 | 1 | |
| 1.609687461 × 1012 | 1 | |
| 1.609687475 × 1012 | 1 | |
| 1.609687477 × 1012 | 1 | |
| 1.609687478 × 1012 | 1 | |
| 1.609687488 × 1012 | 1 | |
| 1.609687493 × 1012 | 1 | |
| 1.609687494 × 1012 | 1 | |
| 1.609687499 × 1012 | 1 | |
| 1.609687502 × 1012 | 2 |
| Value | Count | Frequency (%) |
| 1.614640655 × 1012 | 1 | |
| 1.614634349 × 1012 | 1 | |
| 1.614633448 × 1012 | 1 | |
| 1.614626854 × 1012 | 1 | |
| 1.614622951 × 1012 | 1 | |
| 1.614620855 × 1012 | 1 | |
| 1.614613362 × 1012 | 1 | |
| 1.614607658 × 1012 | 1 | |
| 1.614607054 × 1012 | 1 | |
| 1.614604049 × 1012 | 1 |
pointsAwardedDate
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 523 |
|---|---|
| Distinct (%) | 97.4% |
| Missing | 582 |
| Missing (%) | 52.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6109486 × 1012 |
| Minimum | 1.6040891 × 1012 |
|---|---|
| Maximum | 1.614379 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 KiB |
Quantile statistics
| Minimum | 1.6040891 × 1012 |
|---|---|
| 5-th percentile | 1.6096875 × 1012 |
| Q1 | 1.6100433 × 1012 |
| median | 1.6110896 × 1012 |
| Q3 | 1.6117099 × 1012 |
| 95-th percentile | 1.6124746 × 1012 |
| Maximum | 1.614379 × 1012 |
| Range | 1.0289905 × 1010 |
| Interquartile range (IQR) | 1.666597 × 109 |
Descriptive statistics
| Standard deviation | 1.0567179 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.00065596004 |
| Kurtosis | 6.4349848 |
| Mean | 1.6109486 × 1012 |
| Median Absolute Deviation (MAD) | 7.61714 × 108 |
| Skewness | -1.0478511 |
| Sum | 8.6507938 × 1014 |
| Variance | 1.1166527 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.609687534 × 1012 | 3 | 0.3% |
| 1.609687531 × 1012 | 2 | 0.2% |
| 1.610144383 × 1012 | 2 | 0.2% |
| 1.609788557 × 1012 | 2 | 0.2% |
| 1.609879104 × 1012 | 2 | 0.2% |
| 1.610557181 × 1012 | 2 | 0.2% |
| 1.609788876 × 1012 | 2 | 0.2% |
| 1.611173216 × 1012 | 2 | 0.2% |
| 1.611172426 × 1012 | 2 | 0.2% |
| 1.609687532 × 1012 | 2 | 0.2% |
| Other values (513) | 516 | |
| (Missing) | 582 |
| Value | Count | Frequency (%) |
| 1.60408908 × 1012 | 1 | |
| 1.604900212 × 1012 | 1 | |
| 1.605483857 × 1012 | 1 | |
| 1.605556824 × 1012 | 1 | |
| 1.60968745 × 1012 | 1 | |
| 1.609687459 × 1012 | 1 | |
| 1.609687461 × 1012 | 1 | |
| 1.609687475 × 1012 | 1 | |
| 1.609687476 × 1012 | 1 | |
| 1.609687483 × 1012 | 1 |
| Value | Count | Frequency (%) |
| 1.614378985 × 1012 | 1 | |
| 1.61313912 × 1012 | 1 | |
| 1.613139117 × 1012 | 1 | |
| 1.613139071 × 1012 | 1 | |
| 1.613139065 × 1012 | 1 | |
| 1.613060278 × 1012 | 1 | |
| 1.613060276 × 1012 | 1 | |
| 1.613060266 × 1012 | 1 | |
| 1.613052084 × 1012 | 1 | |
| 1.613052054 × 1012 | 1 |
pointsEarned
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 119 |
|---|---|
| Distinct (%) | 19.5% |
| Missing | 510 |
| Missing (%) | 45.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 585.96289 |
| Minimum | 0 |
|---|---|
| Maximum | 10199.8 |
| Zeros | 4 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 5 |
| median | 150 |
| Q3 | 750 |
| 95-th percentile | 2035.3 |
| Maximum | 10199.8 |
| Range | 10199.8 |
| Interquartile range (IQR) | 745 |
Descriptive statistics
| Standard deviation | 1357.1669 |
|---|---|
| Coefficient of variation (CV) | 2.3161312 |
| Kurtosis | 25.00351 |
| Mean | 585.96289 |
| Median Absolute Deviation (MAD) | 145 |
| Skewness | 4.7279179 |
| Sum | 356851.4 |
| Variance | 1841902.1 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 161 | 14.4% |
| 25 | 63 | 5.6% |
| 750 | 49 | 4.4% |
| 250 | 37 | 3.3% |
| 50 | 27 | 2.4% |
| 840 | 21 | 1.9% |
| 100 | 18 | 1.6% |
| 500 | 17 | 1.5% |
| 300 | 16 | 1.4% |
| 150 | 15 | 1.3% |
| Other values (109) | 185 | 16.5% |
| (Missing) | 510 |
| Value | Count | Frequency (%) |
| 0 | 4 | 0.4% |
| 5 | 161 | |
| 25 | 63 | 5.6% |
| 35 | 7 | 0.6% |
| 50 | 27 | 2.4% |
| 50.6 | 5 | 0.4% |
| 50.9 | 1 | 0.1% |
| 55 | 6 | 0.5% |
| 91.2 | 2 | 0.2% |
| 94.6 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 10199.8 | 1 | 0.1% |
| 9850 | 1 | 0.1% |
| 9449.8 | 1 | 0.1% |
| 9200 | 1 | 0.1% |
| 8950 | 1 | 0.1% |
| 8850 | 1 | 0.1% |
| 8700 | 3 | |
| 7137.2 | 1 | 0.1% |
| 6257.3 | 1 | 0.1% |
| 5850 | 2 |
purchaseDate
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 358 |
|---|---|
| Distinct (%) | 53.4% |
| Missing | 448 |
| Missing (%) | 40.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6085477 × 1012 |
| Minimum | 1.5093216 × 1012 |
|---|---|
| Maximum | 1.615225 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 KiB |
Quantile statistics
| Minimum | 1.5093216 × 1012 |
|---|---|
| 5-th percentile | 1.5976224 × 1012 |
| Q1 | 1.6098048 × 1012 |
| median | 1.6105511 × 1012 |
| Q3 | 1.6116236 × 1012 |
| 95-th percentile | 1.6124832 × 1012 |
| Maximum | 1.615225 × 1012 |
| Range | 1.0590343 × 1011 |
| Interquartile range (IQR) | 1.818778 × 109 |
Descriptive statistics
| Standard deviation | 1.230755 × 1010 |
|---|---|
| Coefficient of variation (CV) | 0.007651343 |
| Kurtosis | 55.265028 |
| Mean | 1.6085477 × 1012 |
| Median Absolute Deviation (MAD) | 8.48982 × 108 |
| Skewness | -7.2846834 |
| Sum | 1.0793355 × 1015 |
| Variance | 1.514758 × 1020 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.5976224 × 1012 | 40 | 3.6% |
| 1.6124832 × 1012 | 28 | 2.5% |
| 1.611792 × 1012 | 24 | 2.1% |
| 1.6104096 × 1012 | 23 | 2.1% |
| 1.6111008 × 1012 | 18 | 1.6% |
| 1.6103232 × 1012 | 14 | 1.3% |
| 1.6118784 × 1012 | 13 | 1.2% |
| 1.6112736 × 1012 | 11 | 1.0% |
| 1.6111872 × 1012 | 11 | 1.0% |
| 1.6105824 × 1012 | 11 | 1.0% |
| Other values (348) | 478 | |
| (Missing) | 448 |
| Value | Count | Frequency (%) |
| 1.5093216 × 1012 | 9 | 0.8% |
| 1.5464736 × 1012 | 1 | 0.1% |
| 1.5976224 × 1012 | 40 | |
| 1.5999552 × 1012 | 1 | 0.1% |
| 1.604002679 × 1012 | 1 | 0.1% |
| 1.604002681 × 1012 | 1 | 0.1% |
| 1.604521418 × 1012 | 1 | 0.1% |
| 1.604606903 × 1012 | 1 | 0.1% |
| 1.604813811 × 1012 | 1 | 0.1% |
| 1.604813817 × 1012 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 1.615225033 × 1012 | 1 | |
| 1.614616873 × 1012 | 1 | |
| 1.614538558 × 1012 | 1 | |
| 1.6141248 × 1012 | 1 | |
| 1.61385007 × 1012 | 1 | |
| 1.613345597 × 1012 | 1 | |
| 1.613235569 × 1012 | 1 | |
| 1.613235566 × 1012 | 1 | |
| 1.613088 × 1012 | 2 | |
| 1.613075216 × 1012 | 1 |
purchasedItemCount
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 50 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 484 |
| Missing (%) | 43.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.75748 |
| Minimum | 0 |
|---|---|
| Maximum | 689 |
| Zeros | 15 |
| Zeros (%) | 1.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 88.1 |
| Maximum | 689 |
| Range | 689 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 61.13424 |
|---|---|
| Coefficient of variation (CV) | 4.1425934 |
| Kurtosis | 62.320237 |
| Mean | 14.75748 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 7.170786 |
| Sum | 9371 |
| Variance | 3737.3954 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 245 | |
| 2 | 113 | 10.1% |
| 5 | 90 | 8.0% |
| 4 | 67 | 6.0% |
| 3 | 23 | 2.1% |
| 0 | 15 | 1.3% |
| 10 | 12 | 1.1% |
| 9 | 10 | 0.9% |
| 6 | 7 | 0.6% |
| 11 | 5 | 0.4% |
| Other values (40) | 48 | 4.3% |
| (Missing) | 484 |
| Value | Count | Frequency (%) |
| 0 | 15 | 1.3% |
| 1 | 245 | |
| 2 | 113 | |
| 3 | 23 | 2.1% |
| 4 | 67 | 6.0% |
| 5 | 90 | 8.0% |
| 6 | 7 | 0.6% |
| 7 | 3 | 0.3% |
| 8 | 2 | 0.2% |
| 9 | 10 | 0.9% |
| Value | Count | Frequency (%) |
| 689 | 1 | |
| 670 | 1 | |
| 599 | 1 | |
| 348 | 1 | |
| 341 | 1 | |
| 335 | 1 | |
| 309 | 1 | |
| 303 | 1 | |
| 240 | 1 | |
| 229 | 1 |
rewardsReceiptItemList
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 440 |
|---|---|
| Missing (%) | 39.3% |
| Memory size | 8.9 KiB |
rewardsReceiptStatus
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 KiB |
| FINISHED | |
|---|---|
| SUBMITTED | |
| REJECTED | |
| PENDING | 50 |
| FLAGGED | 46 |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 8.3020554 |
| Min length | 7 |
Characters and Unicode
| Total characters | 9290 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FINISHED |
|---|---|
| 2nd row | FINISHED |
| 3rd row | REJECTED |
| 4th row | FINISHED |
| 5th row | FINISHED |
Common Values
| Value | Count | Frequency (%) |
| FINISHED | 518 | |
| SUBMITTED | 434 | |
| REJECTED | 71 | 6.3% |
| PENDING | 50 | 4.5% |
| FLAGGED | 46 | 4.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| finished | 518 | |
| submitted | 434 | |
| rejected | 71 | 6.3% |
| pending | 50 | 4.5% |
| flagged | 46 | 4.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 1520 | |
| E | 1261 | |
| D | 1119 | |
| S | 952 | |
| T | 939 | |
| N | 618 | |
| F | 564 | 6.1% |
| H | 518 | 5.6% |
| M | 434 | 4.7% |
| B | 434 | 4.7% |
| Other values (8) | 931 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 9290 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 1520 | |
| E | 1261 | |
| D | 1119 | |
| S | 952 | |
| T | 939 | |
| N | 618 | |
| F | 564 | 6.1% |
| H | 518 | 5.6% |
| M | 434 | 4.7% |
| B | 434 | 4.7% |
| Other values (8) | 931 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9290 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 1520 | |
| E | 1261 | |
| D | 1119 | |
| S | 952 | |
| T | 939 | |
| N | 618 | |
| F | 564 | 6.1% |
| H | 518 | 5.6% |
| M | 434 | 4.7% |
| B | 434 | 4.7% |
| Other values (8) | 931 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9290 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| I | 1520 | |
| E | 1261 | |
| D | 1119 | |
| S | 952 | |
| T | 939 | |
| N | 618 | |
| F | 564 | 6.1% |
| H | 518 | 5.6% |
| M | 434 | 4.7% |
| B | 434 | 4.7% |
| Other values (8) | 931 |
totalSpent
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 94 |
|---|---|
| Distinct (%) | 13.7% |
| Missing | 435 |
| Missing (%) | 38.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 77.796857 |
| Minimum | 0 |
|---|---|
| Maximum | 4721.95 |
| Zeros | 15 |
| Zeros (%) | 1.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 18.2 |
| Q3 | 34.96 |
| 95-th percentile | 290 |
| Maximum | 4721.95 |
| Range | 4721.95 |
| Interquartile range (IQR) | 33.96 |
Descriptive statistics
| Standard deviation | 347.11035 |
|---|---|
| Coefficient of variation (CV) | 4.4617529 |
| Kurtosis | 122.95658 |
| Mean | 77.796857 |
| Median Absolute Deviation (MAD) | 16.76 |
| Skewness | 10.203611 |
| Sum | 53213.05 |
| Variance | 120485.59 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 172 | 15.4% |
| 10 | 54 | 4.8% |
| 28.57 | 50 | 4.5% |
| 34.96 | 44 | 3.9% |
| 49.95 | 43 | 3.8% |
| 25 | 28 | 2.5% |
| 84 | 22 | 2.0% |
| 4.66 | 15 | 1.3% |
| 0 | 15 | 1.3% |
| 9.99 | 14 | 1.3% |
| Other values (84) | 227 | |
| (Missing) | 435 |
| Value | Count | Frequency (%) |
| 0 | 15 | 1.3% |
| 0.16 | 1 | 0.1% |
| 0.99 | 7 | 0.6% |
| 1 | 172 | |
| 2 | 4 | 0.4% |
| 2.23 | 7 | 0.6% |
| 2.29 | 1 | 0.1% |
| 2.99 | 1 | 0.1% |
| 3 | 9 | 0.8% |
| 3.09 | 5 | 0.4% |
| Value | Count | Frequency (%) |
| 4721.95 | 1 | |
| 4566.17 | 1 | |
| 4368.8 | 1 | |
| 2084.82 | 1 | |
| 1198.68 | 1 | |
| 1183.1 | 1 | |
| 1177.84 | 1 | |
| 1107.82 | 1 | |
| 1083.24 | 1 | |
| 1043.18 | 1 |
userId
Categorical
| Distinct | 258 |
|---|---|
| Distinct (%) | 23.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 KiB |
| 5fc961c3b8cfca11a077dd33 | |
|---|---|
| 59c124bae4b0299e55b0f330 | |
| 54943462e4b07e684157a532 | 50 |
| 5fa41775898c7a11a6bcef3e | 21 |
| 5ff5d15aeb7c7d12096d91a2 | 20 |
| Other values (253) |
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 24 |
| Min length | 24 |
Characters and Unicode
| Total characters | 26856 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 167 ? |
|---|---|
| Unique (%) | 14.9% |
Sample
| 1st row | 5ff1e1eacfcf6c399c274ae6 |
|---|---|
| 2nd row | 5ff1e194b6a9d73a3a9f1052 |
| 3rd row | 5ff1e1f1cfcf6c399c274b0b |
| 4th row | 5ff1e1eacfcf6c399c274ae6 |
| 5th row | 5ff1e194b6a9d73a3a9f1052 |
Common Values
| Value | Count | Frequency (%) |
| 5fc961c3b8cfca11a077dd33 | 436 | |
| 59c124bae4b0299e55b0f330 | 58 | 5.2% |
| 54943462e4b07e684157a532 | 50 | 4.5% |
| 5fa41775898c7a11a6bcef3e | 21 | 1.9% |
| 5ff5d15aeb7c7d12096d91a2 | 20 | 1.8% |
| 600fb1ac73c60b12049027bb | 16 | 1.4% |
| 5ff1e194b6a9d73a3a9f1052 | 14 | 1.3% |
| 5ff47392c3d63511e2a47881 | 10 | 0.9% |
| 600987d77d983a11f63cfa92 | 10 | 0.9% |
| 5a43c08fe4b014fd6b6a0612 | 9 | 0.8% |
| Other values (248) | 475 |
Length
| Value | Count | Frequency (%) |
| 5fc961c3b8cfca11a077dd33 | 436 | |
| 59c124bae4b0299e55b0f330 | 58 | 5.2% |
| 54943462e4b07e684157a532 | 50 | 4.5% |
| 5fa41775898c7a11a6bcef3e | 21 | 1.9% |
| 5ff5d15aeb7c7d12096d91a2 | 20 | 1.8% |
| 600fb1ac73c60b12049027bb | 16 | 1.4% |
| 5ff1e194b6a9d73a3a9f1052 | 14 | 1.3% |
| 5ff47392c3d63511e2a47881 | 10 | 0.9% |
| 600987d77d983a11f63cfa92 | 10 | 0.9% |
| 5a43c08fe4b014fd6b6a0612 | 9 | 0.8% |
| Other values (248) | 475 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 2923 | |
| c | 2547 | 9.5% |
| 3 | 2412 | 9.0% |
| f | 1957 | 7.3% |
| 0 | 1795 | 6.7% |
| a | 1695 | 6.3% |
| 7 | 1674 | 6.2% |
| 5 | 1596 | 5.9% |
| d | 1532 | 5.7% |
| b | 1523 | 5.7% |
| Other values (6) | 7202 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 16734 | |
| Lowercase Letter | 10122 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2923 | |
| 3 | 2412 | |
| 0 | 1795 | |
| 7 | 1674 | |
| 5 | 1596 | |
| 6 | 1491 | |
| 9 | 1450 | |
| 8 | 1264 | |
| 4 | 1181 | |
| 2 | 948 | 5.7% |
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 2547 | |
| f | 1957 | |
| a | 1695 | |
| d | 1532 | |
| b | 1523 | |
| e | 868 | 8.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 16734 | |
| Latin | 10122 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 2923 | |
| 3 | 2412 | |
| 0 | 1795 | |
| 7 | 1674 | |
| 5 | 1596 | |
| 6 | 1491 | |
| 9 | 1450 | |
| 8 | 1264 | |
| 4 | 1181 | |
| 2 | 948 | 5.7% |
Latin
| Value | Count | Frequency (%) |
| c | 2547 | |
| f | 1957 | |
| a | 1695 | |
| d | 1532 | |
| b | 1523 | |
| e | 868 | 8.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 26856 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 2923 | |
| c | 2547 | 9.5% |
| 3 | 2412 | 9.0% |
| f | 1957 | 7.3% |
| 0 | 1795 | 6.7% |
| a | 1695 | 6.3% |
| 7 | 1674 | 6.2% |
| 5 | 1596 | 5.9% |
| d | 1532 | 5.7% |
| b | 1523 | 5.7% |
| Other values (6) | 7202 |
| bonusPointsEarned | createDate | dateScanned | finishedDate | modifyDate | pointsAwardedDate | pointsEarned | purchaseDate | purchasedItemCount | totalSpent | bonusPointsEarnedReason | rewardsReceiptStatus | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| bonusPointsEarned | 1.000 | -0.107 | -0.107 | -0.031 | -0.086 | -0.066 | 0.193 | 0.012 | 0.243 | 0.120 | 0.996 | 0.182 |
| createDate | -0.107 | 1.000 | 1.000 | 0.993 | 0.993 | 0.991 | -0.134 | 0.551 | -0.013 | 0.195 | 0.305 | 0.397 |
| dateScanned | -0.107 | 1.000 | 1.000 | 0.993 | 0.993 | 0.991 | -0.134 | 0.551 | -0.013 | 0.195 | 0.305 | 0.397 |
| finishedDate | -0.031 | 0.993 | 0.993 | 1.000 | 1.000 | 1.000 | 0.037 | 0.920 | 0.042 | 0.131 | 0.081 | 0.747 |
| modifyDate | -0.086 | 0.993 | 0.993 | 1.000 | 1.000 | 0.974 | -0.114 | 0.529 | 0.019 | 0.182 | 0.281 | 0.431 |
| pointsAwardedDate | -0.066 | 0.991 | 0.991 | 1.000 | 0.974 | 1.000 | 0.003 | 0.915 | 0.012 | 0.127 | 0.055 | 0.701 |
| pointsEarned | 0.193 | -0.134 | -0.134 | 0.037 | -0.114 | 0.003 | 1.000 | 0.134 | 0.067 | -0.028 | 0.851 | 0.560 |
| purchaseDate | 0.012 | 0.551 | 0.551 | 0.920 | 0.529 | 0.915 | 0.134 | 1.000 | -0.009 | -0.006 | 0.668 | 0.475 |
| purchasedItemCount | 0.243 | -0.013 | -0.013 | 0.042 | 0.019 | 0.012 | 0.067 | -0.009 | 1.000 | 0.644 | 0.119 | 0.077 |
| totalSpent | 0.120 | 0.195 | 0.195 | 0.131 | 0.182 | 0.127 | -0.028 | -0.006 | 0.644 | 1.000 | 0.306 | 0.772 |
| bonusPointsEarnedReason | 0.996 | 0.305 | 0.305 | 0.081 | 0.281 | 0.055 | 0.851 | 0.668 | 0.119 | 0.306 | 1.000 | 0.433 |
| rewardsReceiptStatus | 0.182 | 0.397 | 0.397 | 0.747 | 0.431 | 0.701 | 0.560 | 0.475 | 0.077 | 0.772 | 0.433 | 1.000 |
| _id | bonusPointsEarned | bonusPointsEarnedReason | createDate | dateScanned | finishedDate | modifyDate | pointsAwardedDate | pointsEarned | purchaseDate | purchasedItemCount | rewardsReceiptItemList | rewardsReceiptStatus | totalSpent | userId | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 5ff1e1eb0a720f0523000575 | 500.0 | Receipt number 2 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) | 1609687531000 | 1609687531000 | 1.609688e+12 | 1609687536000 | 1.609688e+12 | 500.0 | 1.609632e+12 | 5.0 | [{'barcode': '4011', 'description': 'ITEM NOT FOUND', 'finalPrice': '26.00', 'itemPrice': '26.00', 'needsFetchReview': False, 'partnerItemId': '1', 'preventTargetGapPoints': True, 'quantityPurchased': 5, 'userFlaggedBarcode': '4011', 'userFlaggedNewItem': True, 'userFlaggedPrice': '26.00', 'userFlaggedQuantity': 5, '_id': '5ff1e1eb0a720f0523000575'}] | FINISHED | 26.00 | 5ff1e1eacfcf6c399c274ae6 |
| 1 | 5ff1e1bb0a720f052300056b | 150.0 | Receipt number 5 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) | 1609687483000 | 1609687483000 | 1.609687e+12 | 1609687488000 | 1.609687e+12 | 150.0 | 1.609601e+12 | 2.0 | [{'barcode': '4011', 'description': 'ITEM NOT FOUND', 'finalPrice': '1', 'itemPrice': '1', 'partnerItemId': '1', 'quantityPurchased': 1, '_id': '5ff1e1bb0a720f052300056b'}, {'barcode': '028400642255', 'description': 'DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ', 'finalPrice': '10.00', 'itemPrice': '10.00', 'needsFetchReview': True, 'needsFetchReviewReason': 'USER_FLAGGED', 'partnerItemId': '2', 'pointsNotAwardedReason': 'Action not allowed for user and CPG', 'pointsPayerId': '5332f5fbe4b03c9a25efd0ba', 'preventTargetGapPoints': True, 'quantityPurchased': 1, 'rewardsGroup': 'DORITOS SPICY SWEET CHILI SINGLE SERVE', 'rewardsProductPartnerId': '5332f5fbe4b03c9a25efd0ba', 'userFlaggedBarcode': '028400642255', 'userFlaggedDescription': 'DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ', 'userFlaggedNewItem': True, 'userFlaggedPrice': '10.00', 'userFlaggedQuantity': 1, '_id': '5ff1e1bb0a720f052300056b'}] | FINISHED | 11.00 | 5ff1e194b6a9d73a3a9f1052 |
| 2 | 5ff1e1f10a720f052300057a | 5.0 | All-receipts receipt bonus | 1609687537000 | 1609687537000 | NaN | 1609687542000 | NaN | 5 | 1.609632e+12 | 1.0 | [{'needsFetchReview': False, 'partnerItemId': '1', 'preventTargetGapPoints': True, 'userFlaggedBarcode': '4011', 'userFlaggedNewItem': True, 'userFlaggedPrice': '26.00', 'userFlaggedQuantity': 3, '_id': '5ff1e1f10a720f052300057a'}] | REJECTED | 10.00 | 5ff1e1f1cfcf6c399c274b0b |
| 3 | 5ff1e1ee0a7214ada100056f | 5.0 | All-receipts receipt bonus | 1609687534000 | 1609687534000 | 1.609688e+12 | 1609687539000 | 1.609688e+12 | 5.0 | 1.609632e+12 | 4.0 | [{'barcode': '4011', 'description': 'ITEM NOT FOUND', 'finalPrice': '28.00', 'itemPrice': '28.00', 'needsFetchReview': False, 'partnerItemId': '1', 'preventTargetGapPoints': True, 'quantityPurchased': 4, 'userFlaggedBarcode': '4011', 'userFlaggedNewItem': True, 'userFlaggedPrice': '28.00', 'userFlaggedQuantity': 4, '_id': '5ff1e1ee0a7214ada100056f'}] | FINISHED | 28.00 | 5ff1e1eacfcf6c399c274ae6 |
| 4 | 5ff1e1d20a7214ada1000561 | 5.0 | All-receipts receipt bonus | 1609687506000 | 1609687506000 | 1.609688e+12 | 1609687511000 | 1.609688e+12 | 5.0 | 1.609601e+12 | 2.0 | [{'barcode': '4011', 'description': 'ITEM NOT FOUND', 'finalPrice': '1', 'itemPrice': '1', 'partnerItemId': '1', 'quantityPurchased': 1, '_id': '5ff1e1d20a7214ada1000561'}, {'barcode': '1234', 'finalPrice': '2.56', 'itemPrice': '2.56', 'needsFetchReview': True, 'needsFetchReviewReason': 'USER_FLAGGED', 'partnerItemId': '2', 'preventTargetGapPoints': True, 'quantityPurchased': 3, 'userFlaggedBarcode': '1234', 'userFlaggedDescription': '', 'userFlaggedNewItem': True, 'userFlaggedPrice': '2.56', 'userFlaggedQuantity': 3, '_id': '5ff1e1d20a7214ada1000561'}] | FINISHED | 1.00 | 5ff1e194b6a9d73a3a9f1052 |
| 5 | 5ff1e1e40a7214ada1000566 | 750.0 | Receipt number 1 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) | 1609687524000 | 1609687524000 | 1.609688e+12 | 1609687530000 | 1.609688e+12 | 750.0 | 1.609601e+12 | 1.0 | [{'barcode': '4011', 'description': 'ITEM NOT FOUND', 'finalPrice': '3.25', 'itemPrice': '3.25', 'needsFetchReview': False, 'originalMetaBriteBarcode': '028400642255', 'originalMetaBriteDescription': 'DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ', 'partnerItemId': '1', 'pointsNotAwardedReason': 'Action not allowed for user and CPG', 'pointsPayerId': '5332f5fbe4b03c9a25efd0ba', 'preventTargetGapPoints': True, 'quantityPurchased': 1, 'rewardsGroup': 'DORITOS SPICY SWEET CHILI SINGLE SERVE', 'rewardsProductPartnerId': '5332f5fbe4b03c9a25efd0ba', 'userFlaggedBarcode': '4011', '_id': '5ff1e1e40a7214ada1000566'}] | FINISHED | 3.25 | 5ff1e1e4cfcf6c399c274ac3 |
| 6 | 5ff1e1cd0a720f052300056f | 5.0 | All-receipts receipt bonus | 1609687501000 | 1609687501000 | 1.609688e+12 | 1609687502000 | 1.609688e+12 | 5.0 | 1.609688e+12 | 1.0 | [{'brandCode': 'MISSION', 'competitorRewardsGroup': 'TACO BELL TACO SHELLS', 'description': 'MSSN TORTLLA', 'discountedItemPrice': '2.23', 'finalPrice': '2.23', 'itemPrice': '2.23', 'originalReceiptItemText': 'MSSN TORTLLA', 'partnerItemId': '1009', 'quantityPurchased': 1, '_id': '5ff1e1cd0a720f052300056f'}] | FINISHED | 2.23 | 5ff1e194b6a9d73a3a9f1052 |
| 7 | 5ff1e1a40a720f0523000569 | 500.0 | Receipt number 2 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) | 1609687460000 | 1609687460000 | 1.609687e+12 | 1609687461000 | 1.609687e+12 | 500.0 | 1.609027e+12 | 1.0 | [{'barcode': '046000832517', 'brandCode': 'BRAND', 'description': 'Old El Paso Mild Chopped Green Chiles, 4.5 Oz', 'finalPrice': '10.00', 'itemPrice': '10.00', 'partnerItemId': '0', 'pointsNotAwardedReason': 'Action not allowed for user and CPG', 'pointsPayerId': '5332f5f3e4b03c9a25efd0ae', 'quantityPurchased': 1, 'rewardsGroup': 'OLD EL PASO BEANS & PEPPERS', 'rewardsProductPartnerId': '5332f5f3e4b03c9a25efd0ae', '_id': '5ff1e1a40a720f0523000569'}] | FINISHED | 10.00 | 5ff1e194b6a9d73a3a9f1052 |
| 8 | 5ff1e1ed0a7214ada100056e | 5.0 | All-receipts receipt bonus | 1609687533000 | 1609687533000 | 1.609688e+12 | 1609687538000 | 1.609688e+12 | 5.0 | 1.609632e+12 | 5.0 | [{'barcode': '4011', 'description': 'ITEM NOT FOUND', 'finalPrice': '20.00', 'itemPrice': '20.00', 'needsFetchReview': False, 'partnerItemId': '1', 'preventTargetGapPoints': True, 'quantityPurchased': 5, 'userFlaggedBarcode': '4011', 'userFlaggedNewItem': True, 'userFlaggedPrice': '20.00', 'userFlaggedQuantity': 5, '_id': '5ff1e1ed0a7214ada100056e'}] | FINISHED | 20.00 | 5ff1e1eacfcf6c399c274ae6 |
| 9 | 5ff1e1eb0a7214ada100056b | 250.0 | Receipt number 3 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36) | 1609687531000 | 1609687531000 | 1.609688e+12 | 1609687536000 | 1.609688e+12 | 250.0 | 1.609632e+12 | 3.0 | [{'barcode': '4011', 'description': 'ITEM NOT FOUND', 'finalPrice': '20.00', 'itemPrice': '20.00', 'needsFetchReview': False, 'partnerItemId': '1', 'preventTargetGapPoints': True, 'quantityPurchased': 3, 'userFlaggedBarcode': '4011', 'userFlaggedNewItem': True, 'userFlaggedPrice': '20.00', 'userFlaggedQuantity': 3, '_id': '5ff1e1eb0a7214ada100056b'}] | FINISHED | 20.00 | 5ff1e1eacfcf6c399c274ae6 |
| _id | bonusPointsEarned | bonusPointsEarnedReason | createDate | dateScanned | finishedDate | modifyDate | pointsAwardedDate | pointsEarned | purchaseDate | purchasedItemCount | rewardsReceiptItemList | rewardsReceiptStatus | totalSpent | userId | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1109 | 603c4a0e0a720fde10000380 | NaN | NaN | 1614563854494 | 1614563854494 | NaN | 1614563854494 | NaN | NaN | NaN | NaN | NaN | SUBMITTED | NaN | 5fc961c3b8cfca11a077dd33 |
| 1110 | 603c6adf0a720fde1000039a | NaN | NaN | 1614572255736 | 1614572255736 | NaN | 1614572255736 | NaN | NaN | NaN | NaN | NaN | SUBMITTED | NaN | 5fc961c3b8cfca11a077dd33 |
| 1111 | 603c9e6e0a720fde100003c7 | NaN | NaN | 1614585454307 | 1614585454307 | NaN | 1614585454307 | NaN | NaN | NaN | NaN | NaN | SUBMITTED | NaN | 5fc961c3b8cfca11a077dd33 |
| 1112 | 603c3d240a720fde10000373 | 25.0 | COMPLETE_NONPARTNER_RECEIPT | 1614560548000 | 1614560548000 | NaN | 1614560549000 | NaN | 25.0 | 1.597622e+12 | 2.0 | [{'barcode': 'B076FJ92M4', 'description': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'discountedItemPrice': '22.97', 'finalPrice': '22.97', 'itemPrice': '22.97', 'originalReceiptItemText': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'partnerItemId': '0', 'priceAfterCoupon': '22.97', 'quantityPurchased': 1, '_id': '603c3d240a720fde10000373'}, {'barcode': 'B07BRRLSVC', 'description': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'discountedItemPrice': '11.99', 'finalPrice': '11.99', 'itemPrice': '11.99', 'originalReceiptItemText': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'partnerItemId': '1', 'priceAfterCoupon': '11.99', 'quantityPurchased': 1, '_id': '603c3d240a720fde10000373'}] | REJECTED | 34.96 | 5fc961c3b8cfca11a077dd33 |
| 1113 | 603cc2bc0a720fde100003e9 | 25.0 | COMPLETE_NONPARTNER_RECEIPT | 1614594748000 | 1614594748000 | NaN | 1614594749000 | NaN | 25.0 | 1.597622e+12 | 2.0 | [{'barcode': 'B076FJ92M4', 'description': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'discountedItemPrice': '22.97', 'finalPrice': '22.97', 'itemPrice': '22.97', 'originalReceiptItemText': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'partnerItemId': '0', 'priceAfterCoupon': '22.97', 'quantityPurchased': 1, '_id': '603cc2bc0a720fde100003e9'}, {'barcode': 'B07BRRLSVC', 'description': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'discountedItemPrice': '11.99', 'finalPrice': '11.99', 'itemPrice': '11.99', 'originalReceiptItemText': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'partnerItemId': '1', 'priceAfterCoupon': '11.99', 'quantityPurchased': 1, '_id': '603cc2bc0a720fde100003e9'}] | REJECTED | 34.96 | 5fc961c3b8cfca11a077dd33 |
| 1114 | 603cc0630a720fde100003e6 | 25.0 | COMPLETE_NONPARTNER_RECEIPT | 1614594147000 | 1614594147000 | NaN | 1614594148000 | NaN | 25.0 | 1.597622e+12 | 2.0 | [{'barcode': 'B076FJ92M4', 'description': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'discountedItemPrice': '22.97', 'finalPrice': '22.97', 'itemPrice': '22.97', 'originalReceiptItemText': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'partnerItemId': '0', 'priceAfterCoupon': '22.97', 'quantityPurchased': 1, '_id': '603cc0630a720fde100003e6'}, {'barcode': 'B07BRRLSVC', 'description': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'discountedItemPrice': '11.99', 'finalPrice': '11.99', 'itemPrice': '11.99', 'originalReceiptItemText': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'partnerItemId': '1', 'priceAfterCoupon': '11.99', 'quantityPurchased': 1, '_id': '603cc0630a720fde100003e6'}] | REJECTED | 34.96 | 5fc961c3b8cfca11a077dd33 |
| 1115 | 603d0b710a720fde1000042a | NaN | NaN | 1614613361873 | 1614613361873 | NaN | 1614613361873 | NaN | NaN | NaN | NaN | NaN | SUBMITTED | NaN | 5fc961c3b8cfca11a077dd33 |
| 1116 | 603cf5290a720fde10000413 | NaN | NaN | 1614607657664 | 1614607657664 | NaN | 1614607657664 | NaN | NaN | NaN | NaN | NaN | SUBMITTED | NaN | 5fc961c3b8cfca11a077dd33 |
| 1117 | 603ce7100a7217c72c000405 | 25.0 | COMPLETE_NONPARTNER_RECEIPT | 1614604048000 | 1614604048000 | NaN | 1614604049000 | NaN | 25.0 | 1.597622e+12 | 2.0 | [{'barcode': 'B076FJ92M4', 'description': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'discountedItemPrice': '22.97', 'finalPrice': '22.97', 'itemPrice': '22.97', 'originalReceiptItemText': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'partnerItemId': '0', 'priceAfterCoupon': '22.97', 'quantityPurchased': 1, '_id': '603ce7100a7217c72c000405'}, {'barcode': 'B07BRRLSVC', 'description': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'discountedItemPrice': '11.99', 'finalPrice': '11.99', 'itemPrice': '11.99', 'originalReceiptItemText': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'partnerItemId': '1', 'priceAfterCoupon': '11.99', 'quantityPurchased': 1, '_id': '603ce7100a7217c72c000405'}] | REJECTED | 34.96 | 5fc961c3b8cfca11a077dd33 |
| 1118 | 603c4fea0a7217c72c000389 | NaN | NaN | 1614565354962 | 1614565354962 | NaN | 1614565354962 | NaN | NaN | NaN | NaN | NaN | SUBMITTED | NaN | 5fc961c3b8cfca11a077dd33 |